Accurate Algorithms for Spatial Operations on the Spheroid in a Spatial Database Management System

[EN] Some of the most powerful spatial analysis software solutions (Oracle, Google Earth Engine, PostgreSQL + PostGIS, etc.) are currently performing geometric calculations directly on the ellipsoid (a quadratic surface that models the earth shape), with a double purpose: to attain a high degree of accuracy and to allow the full management of large areas of territory (countries or even continents). It is well known that both objectives are impossible to achieve by means of the traditional approach using local mathematical projections and Cartesian coordinates. This paper demonstrates in a quantitative methodological way that most of the spatial analysis software products make important deviations in calculations regarding to geodesics, being the users unaware of the magnitude of these inaccuracies, which can easily reach meters depending on the distance. This is due to the use of ellipsoid calculations in an approximate way (e.g., using a sphere instead of an ellipsoid). This paper presents the implementation of two algorithms that solve with high accuracy (less than 100 nm) and efficiently (few iterations) two basic geometric calculations on the ellipsoid that are essential to build more complex spatial operators: the intersection of two geodesics and the minimum distance from a point to a geodesic.Martínez Llario, JC.; Baselga Moreno, S.; Coll-Aliaga, E. (2021). Accurate Algorithms for Spatial Operations on the Spheroid in a Spatial Database Management System. Applied Sciences. 11(11):1-21. https://doi.org/10.3390/app11115129121111

Improving dissolve spatial operations in a simple feature model

[EN] This paper presents an algorithm to improve the performance of a spatial operation called `dissolve¿ widely used in Geographic Information System (GIS) through spatial database systems. In simple feature models (lacking of persistent topology) executing some common spatial operations requires a high amount of system resources. Such common operations occur for example in the `OpenGIS Simple Features for SQL¿ protocol (SFS), a client-server interoperability standard defined by `The Open Geospatial Consortium, Inc.¿ (OGC). The specific spatial operation studied in this paper is called `dissolve¿. It is carried out using the union spatial operator defined by OGC) and consists of removing the boundaries between adjacent polygons. The proposed algorithm improves substantially the performance of this spatial operation and it needs between 100 and 1000 times less amount of resources. This way it enables the database server to carry out this spatial operation on huge datasets containing up to millions of geometries. To check and to validate this algorithm a new open source software package (PGAT) has been developed.This project has been developed in the University of Victoria (British Columbia, Canada) thanks to the Grant awarded by "La Secretaria de Estado de Universidades e Investigacion del Ministerio de Educacion y Ciencia" from Spain (Ref. 2006-0264).Martínez Llario, JC.; Weber-Jahnke, JH.; Coll-Aliaga, E. (2009). Improving dissolve spatial operations in a simple feature model. Advances in Engineering Software. 40(3):170-175. doi:10.1016/j.advengsoft.2008.03.014S17017540

An Assessment and Spatial Modelling of Agricultural Land Abandonment in Spain (2015¿2030)

[EN] This article presents a study based on the outputs from the LUISA Territorial modelling platform (Joint Research Centre of the European Commission) focused on regional and local future projections of land abandonment between 2015 and 2030. Spain is taken as representative of one of the countries highly affected by agricultural land abandonment in the European Union. The most relevant factors driving land abandonment (biophysical, agroeconomics, farm structure and demographic) are described and mapped. Results from the analysis reveal that the Galicia region, northern Spain (Asturias, Cantabria, Gipuzkoa, Bizkaia), north-eastern Spain (Aragon region), central Pyrenees/Ebro basin (Huesca, Navarra, Lleida) and south-eastern Spain (Murcia, Almeria, Alicante, Malaga) are expected to undergo important abandonment processes. The study also concludes that land abandonment within mountainous, high nature value farmland and Natura 2000 areas is lower compared to the outside area without conservation and protection measuresPerpiñá Castillo, C.; Coll-Aliaga, E.; Lavalle, C.; Martínez Llario, JC. (2020). An Assessment and Spatial Modelling of Agricultural Land Abandonment in Spain (2015¿2030). Sustainability. 12(2):1-23. https://doi.org/10.3390/su12020560S123122Gellrich, M., & Zimmermann, N. E. (2007). Investigating the regional-scale pattern of agricultural land abandonment in the Swiss mountains: A spatial statistical modelling approach. Landscape and Urban Planning, 79(1), 65-76. doi:10.1016/j.landurbplan.2006.03.004Alonso‐Sarría, F., Martínez‐Hernández, C., Romero‐Díaz, A., Cánovas‐García, F., & Gomariz‐Castillo, F. (2015). Main Environmental Features Leading to Recent Land Abandonment in Murcia Region (Southeast Spain). Land Degradation & Development, 27(3), 654-670. doi:10.1002/ldr.2447Falcucci, A., Maiorano, L., & Boitani, L. (2006). Changes in land-use/land-cover patterns in Italy and their implications for biodiversity conservation. Landscape Ecology, 22(4), 617-631. doi:10.1007/s10980-006-9056-4Poyatos, R., Latron, J., & Llorens, P. (2003). Land Use and Land Cover Change After Agricultural Abandonment. Mountain Research and Development, 23(4), 362-368. doi:10.1659/0276-4741(2003)023[0362:lualcc]2.0.co;2A Step-By-Step Approach to Building Land Management Scenarios Based on Multiple Viewpoints on Multi-Agent System Simulations Ecology and Society http://jasss.soc.surrey.ac.uk/6/2/2.htmlMacDonald, D., Crabtree, J. ., Wiesinger, G., Dax, T., Stamou, N., Fleury, P., … Gibon, A. (2000). Agricultural abandonment in mountain areas of Europe: Environmental consequences and policy response. Journal of Environmental Management, 59(1), 47-69. doi:10.1006/jema.1999.0335Corbelle-Rico, E., Crecente-Maseda, R., & Santé-Riveira, I. (2012). Multi-scale assessment and spatial modelling of agricultural land abandonment in a European peripheral region: Galicia (Spain), 1956–2004. Land Use Policy, 29(3), 493-501. doi:10.1016/j.landusepol.2011.08.008Leal Filho, W., Mandel, M., Al-Amin, A. Q., Feher, A., & Chiappetta Jabbour, C. J. (2016). An assessment of the causes and consequences of agricultural land abandonment in Europe. International Journal of Sustainable Development & World Ecology, 24(6), 554-560. doi:10.1080/13504509.2016.1240113Van Leeuwen, C. C. E., Cammeraat, E. L. H., de Vente, J., & Boix-Fayos, C. (2019). The evolution of soil conservation policies targeting land abandonment and soil erosion in Spain: A review. Land Use Policy, 83, 174-186. doi:10.1016/j.landusepol.2019.01.018Rey Benayas, J. M. (2007). Abandonment of agricultural land: an overview of drivers and consequences. CAB Reviews: Perspectives in Agriculture, Veterinary Science, Nutrition and Natural Resources, 2(057). doi:10.1079/pavsnnr20072057Terres, J.-M., Scacchiafichi, L. N., Wania, A., Ambar, M., Anguiano, E., Buckwell, A., … Zobena, A. (2015). Farmland abandonment in Europe: Identification of drivers and indicators, and development of a composite indicator of risk. Land Use Policy, 49, 20-34. doi:10.1016/j.landusepol.2015.06.009Prishchepov, A. V., Müller, D., Dubinin, M., Baumann, M., & Radeloff, V. C. (2013). Determinants of agricultural land abandonment in post-Soviet European Russia. Land Use Policy, 30(1), 873-884. doi:10.1016/j.landusepol.2012.06.011Levers, C., Schneider, M., Prishchepov, A. V., Estel, S., & Kuemmerle, T. (2018). Spatial variation in determinants of agricultural land abandonment in Europe. Science of The Total Environment, 644, 95-111. doi:10.1016/j.scitotenv.2018.06.326Lasanta-Martínez, T., Vicente-Serrano, S. M., & Cuadrat-Prats, J. M. (2005). Mountain Mediterranean landscape evolution caused by the abandonment of traditional primary activities: a study of the Spanish Central Pyrenees. Applied Geography, 25(1), 47-65. doi:10.1016/j.apgeog.2004.11.001RODRIGO-COMINO, J., MARTÍNEZ-HERNÁNDEZ, C., ISERLOH, T., & CERDÀ, A. (2018). Contrasted Impact of Land Abandonment on Soil Erosion in Mediterranean Agriculture Fields. Pedosphere, 28(4), 617-631. doi:10.1016/s1002-0160(17)60441-7Cerdà, A., Rodrigo-Comino, J., Novara, A., Brevik, E. C., Vaezi, A. R., Pulido, M., … Keesstra, S. D. (2018). Long-term impact of rainfed agricultural land abandonment on soil erosion in the Western Mediterranean basin. Progress in Physical Geography: Earth and Environment, 42(2), 202-219. doi:10.1177/0309133318758521Arnaez, J., Lasanta, T., Errea, M. P., & Ortigosa, L. (2010). Land abandonment, landscape evolution, and soil erosion in a Spanish Mediterranean mountain region: The case of Camero Viejo. Land Degradation & Development, 22(6), 537-550. doi:10.1002/ldr.1032Romero-Díaz, A., Ruiz-Sinoga, J. D., Robledano-Aymerich, F., Brevik, E. C., & Cerdà, A. (2017). Ecosystem responses to land abandonment in Western Mediterranean Mountains. CATENA, 149, 824-835. doi:10.1016/j.catena.2016.08.013Baumann, M., Kuemmerle, T., Elbakidze, M., Ozdogan, M., Radeloff, V. C., Keuler, N. S., … Hostert, P. (2011). Patterns and drivers of post-socialist farmland abandonment in Western Ukraine. Land Use Policy, 28(3), 552-562. doi:10.1016/j.landusepol.2010.11.003Pazúr, R., Lieskovský, J., Feranec, J., & Oťaheľ, J. (2014). Spatial determinants of abandonment of large-scale arable lands and managed grasslands in Slovakia during the periods of post-socialist transition and European Union accession. Applied Geography, 54, 118-128. doi:10.1016/j.apgeog.2014.07.014Corbelle-Rico, E., & Crecente-Maseda, R. (2014). Evaluating IRENA indicator «Risk of Farmland Abandonment» on a low spatial scale level: The case of Galicia (Spain). Land Use Policy, 38, 9-15. doi:10.1016/j.landusepol.2013.10.013García-Ruiz, J. M. (2010). The effects of land uses on soil erosion in Spain: A review. CATENA, 81(1), 1-11. doi:10.1016/j.catena.2010.01.001Eurostat (2016)—EUROPOP2013, Convergence Scenario, National Level http://epp.eurostat.ec.europa.eu/cache/ITY_SDDS/EN/proj_10c_esms.htmGeneral Equilibrium Model for the Economy-Energy–Environment (GEM-E3) https://ec.europa.eu/jrc/en/gem-e3/modelDynamic Spatial General Equilibrium Model for EU Regions and Sectors (RHOMOLO) https://ec.europa.eu/jrc/en/rhomoloJRC-EU-Times Model Assessing Long Term Role Energy Technologies https://ec.europa.eu/jrc/en/scientific-tool/jrc-eu-times-model-assessing-long-term-role-energy-technologiesBatista e Silva, F., Lavalle, C., & Koomen, E. (2013). A procedure to obtain a refined European land use/cover map. Journal of Land Use Science, 8(3), 255-283. doi:10.1080/1747423x.2012.667450Hilferink, M., & Rietveld, P. (1999). LAND USE SCANNER: An integrated GIS based model for long term projections of land use in urban and rural areas. Journal of Geographical Systems, 1(2), 155-177. doi:10.1007/s101090050010Koomen, E., Diogo, V., Dekkers, J., & Rietveld, P. (2015). A utility-based suitability framework for integrated local-scale land-use modelling. Computers, Environment and Urban Systems, 50, 1-14. doi:10.1016/j.compenvurbsys.2014.10.002Perpiña Castillo, C., Lavalle, C., Baranzelli, C., & Mubareka, S. (2015). Modelling the spatial allocation of second-generation feedstock (lignocellulosic crops) in Europe. International Journal of Geographical Information Science, 29(10), 1807-1825. doi:10.1080/13658816.2015.1051486Kompil, M., Jacobs-Crisioni, C., Dijkstra, L., & Lavalle, C. (2019). Mapping accessibility to generic services in Europe: A market-potential based approach. Sustainable Cities and Society, 47, 101372. doi:10.1016/j.scs.2018.11.047Jacobs-Crisioni, C., Batista e Silva, F., Lavalle, C., Baranzelli, C., Barbosa, A., & Perpiña Castillo, C. (2016). Accessibility and territorial cohesion in a case of transport infrastructure improvements with changing population distributions. European Transport Research Review, 8(1). doi:10.1007/s12544-016-0197-5European Commission–Joint Research Centre https://urban.jrc.ec.europa.eu/#/enEuropean Commission–Joint Research Centre https://ec.europa.eu/knowledge4policy/online-resource/territorial-dashboard_enEuropean Commission, Eurostat http://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/administrative-units-statistical-units/nutsLUISA Collection, Data Catalogue https://data.jrc.ec.europa.eu/collection/luisaLUISA Territorial Modelling Platform https://ec.europa.eu/jrc/en/luisaGlobal Agro-Ecological Zones—GAEZ Portal http://www.gaez.iiasa.ac.at/Data for the Soil Information System for the MARS Crop Yield Forecasting System (SINFO) https://esdac.jrc.ec.europa.eu/sinfo-soil-data-mars-informationSpatial Data Version 1.1 https://esdac.jrc.ec.europa.eu/content/european-food-safety-authority-efsa-data-persam-software-toolFarm structure surveys (FSS)-Structure of agricultural holdings https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Main_PageSpecial request of microdata to DG Agriculture and rural Development, Farm Economics Unit http://ec.europa.eu/agriculture/rica/Eliasson, Å., Jones, R. J. A., Nachtergaele, F., Rossiter, D. G., Terres, J.-M., Van Orshoven, J., … Le Bas, C. (2010). Common criteria for the redefinition of Intermediate Less Favoured Areas in the European Union. Environmental Science & Policy, 13(8), 766-777. doi:10.1016/j.envsci.2010.08.003High Nature Value (HNV) Farmland. European Environment Agency, Copenhagen, Denmark http://www.eea.europa.eu/data-and-maps/data/high-nature-value-farmlandNatura 2000 Data—the European Network of Protected Sites. European Environment Agency, Copenhagen, Denmark http://www.eea.europa.eu/data-and-maps/data/natura-8Walford, N. (2002). Agricultural adjustment: adoption of and adaptation to policy reform measures by large-scale commercial farmers. Land Use Policy, 19(3), 243-257. doi:10.1016/s0264-8377(02)00018-2Renwick, A., Jansson, T., Verburg, P. H., Revoredo-Giha, C., Britz, W., Gocht, A., & McCracken, D. (2013). Policy reform and agricultural land abandonment in the EU. Land Use Policy, 30(1), 446-457. doi:10.1016/j.landusepol.2012.04.005Bakker, M. M., Govers, G., van Doorn, A., Quetier, F., Chouvardas, D., & Rounsevell, M. (2008). The response of soil erosion and sediment export to land-use change in four areas of Europe: The importance of landscape pattern. Geomorphology, 98(3-4), 213-226. doi:10.1016/j.geomorph.2006.12.027Westhoek, H. J., van den Berg, M., & Bakkes, J. A. (2006). Scenario development to explore the future of Europe’s rural areas. Agriculture, Ecosystems & Environment, 114(1), 7-20. doi:10.1016/j.agee.2005.11.005Müller, D., Leitão, P. J., & Sikor, T. (2013). Comparing the determinants of cropland abandonment in Albania and Romania using boosted regression trees. Agricultural Systems, 117, 66-77. doi:10.1016/j.agsy.2012.12.010Correia, T. P. (1993). Threatened landscape in Alentejo, Portugal: the ‘montado’ and other ‘agro-silvo-pastoral’ systems. Landscape and Urban Planning, 24(1-4), 43-48. doi:10.1016/0169-2046(93)90081-nNunes, A. N., de Almeida, A. C., & Coelho, C. O. A. (2011). Impacts of land use and cover type on runoff and soil erosion in a marginal area of Portugal. Applied Geography, 31(2), 687-699. doi:10.1016/j.apgeog.2010.12.006Calatrava, J., Barberá, G. G., & Castillo, V. M. (2011). Farming practices and policy measures for agricultural soil conservation in semi-arid Mediterranean areas: The case of the Guadalentín basin in southeast Spain. Land Degradation & Development, 22(1), 58-69. doi:10.1002/ldr.1013Nadal-Romero, E., Cammeraat, E., Pérez-Cardiel, E., & Lasanta, T. (2016). Effects of secondary succession and afforestation practices on soil properties after cropland abandonment in humid Mediterranean mountain areas. Agriculture, Ecosystems & Environment, 228, 91-100. doi:10.1016/j.agee.2016.05.003Sanjuán, Y., Arnáez, J., Beguería, S., Lana-Renault, N., Lasanta, T., Gómez-Villar, A., … García-Ruiz, J. M. (2017). Woody plant encroachment following grazing abandonment in the subalpine belt: a case study in northern Spain. Regional Environmental Change, 18(4), 1103-1115. doi:10.1007/s10113-017-1245-ySauer, T., & Ries, J. B. (2008). Vegetation cover and geomorphodynamics on abandoned fields in the Central Ebro Basin (Spain). Geomorphology, 102(2), 267-277. doi:10.1016/j.geomorph.2008.05.006Vila Subirós, J., Rodríguez‐Carreras, R., Varga, D., Ribas, A., Úbeda, X., Asperó, F., … Outeiro, L. (2015). Stakeholder Perceptions of Landscape Changes in the Mediterranean Mountains of the North‐Eastern Iberian Peninsula. Land Degradation & Development, 27(5), 1354-1365. doi:10.1002/ldr.2337Badia, A., Pèlachs, A. Vera, A., Tulla, A. F., & Soriano, J. M. (2014). Cambios en los usos y cubiertas del suelo y los efectos en la vulnerabilidad en las comarcas de montaña de Cataluña. Del rol del fuego como herramienta de gestión a los incendios como amenaza. Pirineos, 169(0), e001. doi:10.3989/pirineos.2014.169001Verburg, P. H., & Overmars, K. P. (2009). Combining top-down and bottom-up dynamics in land use modeling: exploring the future of abandoned farmlands in Europe with the Dyna-CLUE model. Landscape Ecology, 24(9), 1167-1181. doi:10.1007/s10980-009-9355-

Evaluación de las competencias de trabajo en equipo y liderazgo y la comunicación efectiva en la asignatura de Distribución de la información espacial del MUIGG

[EN] This paper presents a real case used in the subject of master's degree for the evaluation of the transversal competences of leadership and team work and effective communication. The students develop these cross-disciplinary competences as well as the specific competences of the subject by acquiring a better understanding of the real work environment.[ES] Este trabajo presenta un caso real utilizado en la asignatura de máster para la evaluación de las competencias transversales de liderazgo y trabajo en equipo y comunicación efectiva. Los estudiantes desarrollan dichas competencias transversales a la vez que las competencias específicas de la materia adquiriendo una mejor comprensión del entorno de trabajo real.Coll Aliaga, PE.; Martínez Llario, JC. (2018). Evaluación de las competencias de trabajo en equipo y liderazgo y la comunicación efectiva en la asignatura de Distribución de la información espacial del MUIGG. En IN-RED 2018. IV Congreso Nacional de Innovación Educativa y Docencia en Red. Editorial Universitat Politècnica de València. 1204-12011. https://doi.org/10.4995/INRED2018.2018.8887OCS12041201

La coevaluación y autoevaluación en la asignatura de Distribución de la Información Espacial del MUIGG en la UPV

[ES] En la evaluación de la asignatura de Distribución espacial del Máster Universitario en Ingeniería en Geomática y Geoinformación (MUIGG) de la Universitat Politècnica de València se utilizan, entre otras técnicas las de coevaluación y autoevaluación. Se pretende con ello evaluar parte de las competencias específicas y transversales que el estudiante debe alcanzar en la asignatura. Con la autoevaluación, el estudiante reflexiona de lo que está aprendiendo y hace que sea capaz de reconocer sus fortalezas y debilidades permitiendo que se responsabilice de mejorar su propio proceso de aprendizaje. En la coevaluación los compañeros se valoran entre ellos y este tipo de evaluación permite que los estudiantes sean más activos en clase, Ellos deben ser capaces de expresar juicios críticos sobre sus compañeros y recibir una retroalimentación que les ayude a mejorar en su aprendizaje. En este artículo se muestran los procesos seguidos en clase con las temporizaciones y rubricas utilizadas, así como los resultados obtenidos en los dos últimos cursos académicos.Coll Aliaga, PE.; Martínez Llario, JC. (2019). La coevaluación y autoevaluación en la asignatura de Distribución de la Información Espacial del MUIGG en la UPV. En INNODOCT/18. International Conference on Innovation, Documentation and Education. Editorial Universitat Politècnica de València. 637-9344. https://doi.org/10.4995/INN2018.2018.8821OCS637934

Mejora de la planificación temporal y adaptación de la metodología docente de la asignatura de IDEs del grado de Ingeniería Geomática mediante estadísticos de encuestas anónimas de horas dedicadas

[EN] In this paper, a teaching methodology adapted to support a very flexible way of delivery times of the practical contents of a subject. The aim is to give the student the possibility of using many more hours than the average in a given module in order to avoid sending incomplete tasks or abandoning the subject. To do this, a series of surveys are used and with its statisticians the schedule of the subject is designed for the next course. In addition, the methodology is adapted with reverse teaching and principally all the contents are adapted to give the possibility to the student to finish any task outside teaching hours.[ES] En este artículo presentamos una metodología docente adaptada para soportar tiempos de entrega de los contenidos prácticas de una asignatura de forma muy flexible. Se busca dar la posibilidad al alumno de utilizar muchas más horas que la media en un determinado módulo para así evitar el envío de tareas incompletas o abandono de la asignatura. Para ello, se utilizan una serie de encuestas y con sus estadísticos se diseña el cronograma de la asignatura para el curso siguiente. Además, se adapta la metodología con docencia inversa y principalmente se adaptan todos los contenidos para dar la posibilidad al alumno de finalizar cualquier tarea fuera de horario docente.Martínez Llario, JC.; Coll Aliaga, PE. (2018). Mejora de la planificación temporal y adaptación de la metodología docente de la asignatura de IDEs del grado de Ingeniería Geomática mediante estadísticos de encuestas anónimas de horas dedicadas. En IN-RED 2018. IV Congreso Nacional de Innovación Educativa y Docencia en Red. Editorial Universitat Politècnica de València. 570-576. https://doi.org/10.4995/INRED2018.2018.8886OCS57057

Contribution of green urban areas to the achievement of SDGs. Case study in Valencia (Spain)

[EN] The Agenda for Sustainable Development 2030 of United Nations is made up of the 17 Sustainable Development Goals (SDGs) that humanity will have to meet by 2030. In achieving the SDGs, green urban areas (GUA) play a fundamental role at the local level as they provide recreational and bioclimatic regulatory functions and act as a carbon sink, as well. Specifically, the GUAs contribute directly to three SDGs: SDG 11 Sustainable cities and communities, SDG 13 Climate Action and SDG 15 Life on land. This paper evaluates direct contribution of GUA to this SDGs with high spatial resolution in the case study of the city of Valencia (Spain). The evaluation carried out has made it possible to make a diagnosis of the quantity and accessibility of GUA at sub-neighbourhood level. The results for SDG 11 show that only 9.23% of the population do not have desirable access to GUA and 2.73% live in areas without easy walking distance access to GUA. On the other hand, the evaluation of SDG 15 shows that each inhabitant has at their disposal 10 m2 of GUA, below the average of cities of more than 250,000 inhabitants in Spain. The high spatial resolution of the evaluation has also made it possible to identify the city areas with the worst access to GUA and the least amount of GUA per inhabitant. In consequence, the results allow determining zones with high potential to improve. Additionally, the quantification of the CO2 fixed by the GUA carried out for the evaluation of SDG 13, shows that the fixed carbon is equivalent to 0.04% of total gross GHG emissions of the city and is 36% higher than the total GHG emissions of the annual fuel consumption of the total fleet in the city. Finally, the monitoring of the indicators applied allows evaluating the evolution of the GUA to improve the sustainable development of the city.We are grateful to the Valencia City Council, specifically the Department of Open Government and Transparency directed by Elisa Valia, through the DataGovernance VLC university chair, for being able to make available much of the data necessary for this research. We are also thankful to the company GreenUrbanData, which provided tech-nical expertise that greatly assisted the research. Finally, we also thank the scientific support of Dr Carolina Perpina and Dr Carlo Lavalle of the Joint Research Centre (JRC) of the European Commission (Directorate B-Growth and Innovation, Territorial Development Unit B3) for their scientific support within the framework of collaboration agreement (No. 35930) to contribute to analyse field of urban sustainability indicators, where Valencia acts a City Lab under the framework of the EU Com-munity of Practice on CITIES. Funding sources This work was supported by the Regional Agency of Innovation of Valencia/Spain (AVI) in the project TRUST "Sustainable urban transition through metrics for public decision based on big data" (INNEST00/18/005) .Lorenzo-Sáez, E.; Lerma Arce, V.; Coll-Aliaga, E.; Oliver Villanueva, JV. (2021). Contribution of green urban areas to the achievement of SDGs. Case study in Valencia (Spain). Ecological Indicators. 131:1-11. https://doi.org/10.1016/j.ecolind.2021.108246S11113

Planning and development of new data model for urban scales, the BTU

[EN] This is a small outline about the processes (steps, meetings, agreements, analysis, etc.) which are necessary to elaborate a new data model designed and developed to satisfy the needs of Spanish Local Administrations and Public Authorities. This new data model is designed to consider printable entities at urban scales, complementing the existent data model for smaller scales, the BTA, which have been developed recently. The data model is under development, so the future tasks which are planned might change a little bit but not too much because the goal is very clear: to produce a data model highly interoperable and compatible for big scales.This project is a part of the research project “MOCAIDE”, Creation and cartographic feeding of spatial data infrastructures at the Local Administration trough a data model integrating cadastre, urban planning and historic heritage, with reference CSO2008-04808 and financed by the CICYT and European funds.Coll Aliaga, E.; Ruiz López, F.; Martínez Llario, JC. (2012). Planning and development of new data model for urban scales, the BTU. Procedia Computer Science. 1:10-14. https://doi.org/10.1016/j.protcy.2012.02.004S1014

SDI as an instrument to respond to the local administration's needs and obligations. The example of IDEBarcelona

[ES] La administración local es productora y usuaria de grandes volúme-nes de geoinformación, muy útil para realizar análisis, diagnóstico, planificación y gestión y, en general, diseño y aplicación de políticas públicas. Si esa información está armonizada, facilita la aplicación de políticas comunes a nivel supramunicipal.Las IDE locales dan respuesta a muchas obligaciones de la adminis-tración local establecidas por ley, además de la publicación mediante servicios INSPIRE de la información geográfica de su competencia (Directiva INSPIRE y transposición, LISIGE) y satisfacer necesidades de la gestión y gobernanza municipales.En la Diputación de Barcelona, la IDE está implementada sobre la pla-taforma SITMUN. En el geoportal se publican los recursos disponibles: una herramienta SIG web que ofrece servicio a los ayuntamientos barceloneses, las entidades municipales descentralizadas (EMD), los consells comarcals y la propia Diputación; servicios INSPIRE; un nomenclátor basado en la base de datos geográfica; un catálogo de metadatos, y los portales IDE de los ayuntamientos de Barcelona.La plataforma SITMUN promueve la homogeneización de los datos espaciales y ayuda en la implementación de la Directiva INSPIRE. Dis-poner de recursos IDE y una base centralizada de geodatos, con más de 700 capas, facilita responder a las obligaciones y necesidades de las administraciones locales.[EN] Local administration acts both as producer and user of large volumes of geoinformation, very useful for analysis, diagnosis, planning and manage-ment and, in general, design and implementation of public policies. If this information is harmonized, it facilitates the implementation of common policies at the supra-municipal level.Local SDIs respond to many obligations of the local administration es-tablished by law, in addition to the publication through INSPIRE services of geographic information under its competence (INSPIRE Directive and transposition, LISIGE) and the satisfaction of the needs of municipal ma-nagement and governance.In the Diputación de Barcelona, the SDI is implemented on the SITMUN platform. The geoportal publishes the available resources: a web GIS tool that offers services to Barcelona city councils, decentralized municipal en-tities (EMD), regional councils and the Diputacióm itself; INSPIRE services; a gazetteer based on the geodatabase; a metadata catalog, and the SDI portals of Barcelona city councils.The SITMUN platform promotes the homogenization of spatial data and helps in the implementation of the INSPIRE Directive. Having SDI resources and a centralized geodatabase, with more than 700 layers, makes it easier to respond to the obligations and needs of local administrations.Saez Burgaya, J.; Coll-Aliaga, E.; Martínez Llario, JC. (2020). La IDE como instrumento para dar respuesta a necesidades y obligaciones de la administración local. El ejemplo de la IDEBarcelona. Mapping. 29(203):38-45. http://hdl.handle.net/10251/171693S38452920

Development of interdisciplinary transversal skills through collaborative learning. Case proposal between subjects of the Degree in Engineering in Geomatics and Topography and the Degree in Engineering in Industrial Technologies

[EN] A collaborative proposal is proposed between students of the 4th year of Engineering in Industrial Technologies and 4th year of Engineering in Geomatics and Topography of the Polytechnic University of Valencia. Thus, interdisciplinary groups of students of both degrees will be formed to acquire at the same time transversal competences. A spatial analysis will be carried out by the students of advanced Geographical Information Systems (GIS) that builded from the parameters that the students of Engineering Projects have considered in order to carry out the selection of an industrial plot suitable for the needs of the industry selected for the study. The results of the work will be presented orally to the teachers of both subjects and the requirements of the project will be explained following the specifications of each of the subjects. Thus, the students groups can write the project been able to use Geographic Information Systems to obtain the most optimal location of an industrial plot to develop a more complete project.[ES] Se plantea una propuesta colaborativa entre estudiantes del 4 curso de Ingeniería en Tecnologías Industriales y 4 curso de Ingeniería en Geomática y Topografía de la Universitat Politècnica de València, para formar grupos interdisciplinares de estudiantes de ambos grados y conseguir adquirir a la vez competencias transversales.Se realizará un análisis espacial por los estudiantes de Sistemas de Información Geográfica (SIG) avanzado construido en base a los parámetros que los estudiantes de la asignatura de Proyectos de Ingeniería hayan considerado para poder llevar a cabo la selección de un polígono industrial apto para las necesidades de la industria seleccionada para el estudio.Los resultados del trabajo se expondrán de forma oral a los profesores de ambas asignaturas y se explicarán los requerimientos del proyecto siguiendo las especificaciones de cada una de las asignaturas. Esto permitirá que el grupo de estudiantes redacte el proyecto y sea capaz de utilizar los Sistemas de Información Geográfica para poder obtener la localización más optima de una parcela industrial y de esta forma ser capaz de obtener un proyecto más completo.Coll Aliaga, PE.; Lorenzo Sáez, E.; Lerma Arce, V. (2022). Desarrollo de competencias transversales interdisciplinares a través del aprendizaje colaborativo. Propuesta de caso entre asignaturas del Grado de Ingeniería en Geomática y Topografía y del Grado de Ingeniería en Tecnologías Industriales. Editorial Universitat Politècnica de València. 369-378. https://doi.org/10.4995/INRED2022.2022.1590136937